Internal Error while compiling Pro*C program

------_=_NextPart_001_01C76CAA.6937FC30
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable


Hi



While executing the make -f aggregator_proc.mk cnm_atmfr_aggregator

=20

while compiling i am facing following error :

=20

proc config=3D/opt/cnm/ld/7.0/shared/pcscfg.cfg iname=3Dcnm_aggregator

=20

Pro*C/C++: Release 10.2.0.2.0 - Production on Thu Mar 22 10:41:07 2007

=20

Copyright (c) 1982, 2005, Oracle. All rights reserved.

=20

System default option values taken from:
/usr/local/opt/oracle/product/ldcnmd/precomp/admin/pcscfg.cf g

=20

=20

INTERNAL ERROR: Failed assertion [PGE Code=3D90105]

=20

*** Error code 139

make: Fatal error: Command failed for target `cnm_aggregator.c'

=20

=20

=20

could u plz let me know, what could cause the error and plz tell how to
solve this issue.

=20

=20

Thanks & Regards

Ravi

=20



==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== ====

=20
Disclaimer:

This message and the information contained herein is proprietary and=
confidential and subject to the Tech Mahindra policy statement, you may=
review at =3D"http://www.techmahindra.com/Disclaimer.html">http://www. techmahindra.co=
m/Disclaimer.html externally and =3D"http://tim.techmahindra.com/Disclaimer.html">http://tim. techmahindra.co=
m/Disclaimer.html internally within Tech Mahindra.

==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== ====
------_=_NextPart_001_01C76CAA.6937FC30--

RE: Internal Error while compiling Pro*C program

This doesn't look like a Perl/DBI issue.

Google is my friend, it can be yours also:
http://www.google.com/search?q=3DINTERNAL+ERROR%3A+Failed+as sertion+%5BPG=
E
+Code%3D90105%5D&ie=3Dutf-8&oe=3Dutf-8&aq=3Dt&rls=3Dorg.mozi lla:en-US:off=
icial&c
lient=3Dfirefox-a


-----Original Message-----
From: RaviChandra Chelikam [mailto:rchelikam@TechMahindra.com]=20
Sent: Thursday, March 22, 2007 11:49 AM
To: dbi-users@perl.org
Subject: Internal Error while compiling Pro*C program


Hi



While executing the make -f aggregator_proc.mk cnm_atmfr_aggregator

=20

while compiling i am facing following error :

=20

proc config=3D/opt/cnm/ld/7.0/shared/pcscfg.cfg iname=3Dcnm_aggregator

=20

Pro*C/C++: Release 10.2.0.2.0 - Production on Thu Mar 22 10:41:07 2007

=20

Copyright (c) 1982, 2005, Oracle. All rights reserved.

=20

System default option values taken from:
/usr/local/opt/oracle/product/ldcnmd/precomp/admin/pcscfg.cf g

=20

=20

INTERNAL ERROR: Failed assertion [PGE Code=3D90105]

=20

*** Error code 139

make: Fatal error: Command failed for target `cnm_aggregator.c'

=20

=20

=20

could u plz let me know, what could cause the error and plz tell how to
solve this issue.

=20

=20

Thanks & Regards

Ravi

=20



==================== =====3D=
==================== =====3D=
==================== ==
==================== =====3D=
==================== =====3D=
==

=20
Disclaimer:

This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review at href=3D"http://www.techmahindra.com/Disclaimer.html">http:// www.techmahin=
d
ra.com/Disclaimer.html externally and href=3D"http://tim.techmahindra.com/Disclaimer.html">http:// tim.techmahin=
d
ra.com/Disclaimer.html internally within Tech Mahindra.

==================== =====3D=
==================== =====3D=
==================== ==
==================== =====3D=
==================== =====3D=
==

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

help with my perl script

--0-622023692-1174685600=:10605
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Dear group, I know it is not DBI related problem, but it is hard to find some one who knows perl, shell and Oracle.

I am trying to write a RMAN script,
======
#!/usr/bin/perl

my $ORACLE_HOME = "/opt/oracle/product_10g/test/10.2";
$ENV{ORACLE_HOME}=$ORACLE_HOME;
my $ORACLE_SID="test";
$ENV{ORACLE_SID}=test;
my $backup_log = "/backup/backup_log.log";

open RMAN, "| /opt/oracle/product_10g/eratest/10.2/bin/rman target=sys/temp log=$backup_log" or die "Can't pipe to $!";
print RMAN "exit\n";
close RMAN;
======

It works in command line, but when I put it into crontab job, I always get
===================
connected to target database (not started)
RMAN>
===================
The script does not recognize the sid, what can I do to fix it?

Thanks very much for your help.


---------------------------------
No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.
--0-622023692-1174685600=:10605--

RE: help with my perl script

------_=_NextPart_001_01C76D98.061129F0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

See below ...

=20

________________________________

From: joe bayer [mailto:joebayerii@yahoo.com]=20
Sent: Friday, March 23, 2007 3:33 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: help with my perl script

=20

Dear group, I know it is not DBI related problem, but it is hard to
find some one who knows perl, shell and Oracle.

I am trying to write a RMAN script,=20
======
#!/usr/bin/perl

my $ORACLE_HOME =3D "/opt/oracle/product_10g/test/10.2";
$ENV{ORACLE_HOME}=3D$ORACLE_HOME;
my $ORACLE_SID=3D"test";
$ENV{ORACLE_SID}=3Dtest; # what is this? Shouldn't this read
$ENV{ORACLE_SID}=3D$ORACLE_SID or $ENV{ORACLE_SID}=3D"test"
my $backup_log =3D "/backup/backup_log.log";

open RMAN, "| /opt/oracle/product_10g/eratest/10.2/bin/rman
target=3Dsys/temp log=3D$backup_log" or die "Can't pipe to $!";
print RMAN "exit\n";
close RMAN;
======

It works in command line, but when I put it into crontab job, I always
get=20
===================3D
connected to target database (not started)
RMAN>=20
===================3D
The script does not recognize the sid, what can I do to fix it?

Thanks very much for your help.

=20

________________________________

No need to miss a message. Get email on-the-go
=20
with Yahoo! Mail for Mobile. Get started.
=20


This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.


------_=_NextPart_001_01C76D98.061129F0--

Re: help with my perl script

Le vendredi 23 mars 2007 à 14:33 -0700, joe bayer a écrit :


> my $ORACLE_SID="test";
> $ENV{ORACLE_SID}=test;
^^^^
Could this be your culprit ? Try with either
$ENV{ORACLE_SID}="test";
or
$ENV{ORACLE_SID}=$ORACLE_SID;

--
Olivier

RE: help with my perl script

--0-497974710-1174688719=:8425
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Thanks for your prompt response.

I tried
$ENV{ORACLE_SID}=$ORACLE_SID or $ENV{ORACLE_SID}=”test”

It did not work.



"Reidy, Ron" wrote: v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} st1\:*{behavior:url(#default#ieooui) } See below …


---------------------------------

From: joe bayer [mailto:joebayerii@yahoo.com]
Sent: Friday, March 23, 2007 3:33 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: help with my perl script


Dear group, I know it is not DBI related problem, but it is hard to find some one who knows perl, shell and Oracle.

I am trying to write a RMAN script,
======
#!/usr/bin/perl

my $ORACLE_HOME = "/opt/oracle/product_10g/test/10.2";
$ENV{ORACLE_HOME}=$ORACLE_HOME;
my $ORACLE_SID="test";
$ENV{ORACLE_SID}=test; # what is this? Shouldn’t this read $ENV{ORACLE_SID}=$ORACLE_SID or $ENV{ORACLE_SID}=”test”
my $backup_log = "/backup/backup_log.log";

open RMAN, "| /opt/oracle/product_10g/eratest/10.2/bin/rman target=sys/temp log=$backup_log" or die "Can't pipe to $!";
print RMAN "exit\n";
close RMAN;
======

It works in command line, but when I put it into crontab job, I always get
===================
connected to target database (not started)
RMAN>
===================
The script does not recognize the sid, what can I do to fix it?

Thanks very much for your help.


---------------------------------

No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.


---------------------------------
This electronic message transmission is a PRIVATE communication which contains information
which may be confidential or privileged. The information is intended to be for the use of the individual
or entity named above. If you are not the intended recipient, please be aware that any disclosure,
copying, distribution or use of the contents of this information is prohibited. Please notify the sender
of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0),
and then delete it from your system.



---------------------------------
No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.
--0-497974710-1174688719=:8425--

RE: help with my perl script

------_=_NextPart_001_01C76DA1.EA2F2228
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Then there is something wrong with your environment. Have you tried
using oraenv to set you environment vs. setting the %ENV hash? In cron,
it would look like this:

=20

(export ORAENV_ASK=3DNO && export ORACLE_SID=3Dtest && . oraenv &&
/path/to/rman/script)

=20

There are other environment variables that are set in oraenv.

=20

Another question I have to ask - is the DB running? =20

=20

--

Ron Reidy

Lead DBA

Array BioPharma, Inc.

=20

________________________________

From: joe bayer [mailto:joebayerii@yahoo.com]=20
Sent: Friday, March 23, 2007 4:25 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: RE: help with my perl script

=20

Thanks for your prompt response.

I tried=20
$ENV{ORACLE_SID}=3D$ORACLE_SID or $ENV{ORACLE_SID}=3D"test"

It did not work.



"Reidy, Ron" wrote:

See below ...

=20

________________________________

From: joe bayer [mailto:joebayerii@yahoo.com]=20
Sent: Friday, March 23, 2007 3:33 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: help with my perl script

=20

Dear group, I know it is not DBI related problem, but it is hard to
find some one who knows perl, shell and Oracle.

I am trying to write a RMAN script,=20
======
#!/usr/bin/perl

my $ORACLE_HOME =3D "/opt/oracle/product_10g/test/10.2";
$ENV{ORACLE_HOME}=3D$ORACLE_HOME;
my $ORACLE_SID=3D"test";
$ENV{ORACLE_SID}=3Dtest; # what is this? Shouldn't this read
$ENV{ORACLE_SID}=3D$ORACLE_SID or $ENV{ORACLE_SID}=3D"test"
my $backup_log =3D "/backup/backup_log.log";

open RMAN, "| /opt/oracle/product_10g/eratest/10.2/bin/rman
target=3Dsys/temp log=3D$backup_log" or die "Can't pipe to $!";
print RMAN "exit\n";
close RMAN;
======

It works in command line, but when I put it into crontab job, I always
get=20
===================3D
connected to target database (not started)
RMAN>=20
===================3D
The script does not recognize the sid, what can I do to fix it?

Thanks very much for your help.

=20

________________________________

No need to miss a message. Get email on-the-go
=20
with Yahoo! Mail for Mobile. Get started.
=20

________________________________

size=3D2 width=3D"100%" align=3Dcenter>=20

This electronic message transmission is a PRIVATE communication which
contains information=20
which may be confidential or privileged. The information is intended to
be for the use of the individual=20
or entity named above. If you are not the intended recipient, please be
aware that any disclosure,=20
copying, distribution or use of the contents of this information is
prohibited. Please notify the sender=20
of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0),=20
and then delete it from your system.

=20

=20

________________________________

No need to miss a message. Get email on-the-go
=20
with Yahoo! Mail for Mobile. Get started.
=20


------_=_NextPart_001_01C76DA1.EA2F2228--

RE: help with my perl script

--0-312298244-1174699665=:10696
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Yes, DB is running. If I run
../test.sh, there is no problem.

The problem comes only when I put it in cron.



"Reidy, Ron" wrote: v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} st1\:*{behavior:url(#default#ieooui) } Then there is something wrong with your environment. Have you tried using oraenv to set you environment vs. setting the %ENV hash? In cron, it would look like this:

(export ORAENV_ASK=NO && export ORACLE_SID=test && . oraenv && /path/to/rman/script)

There are other environment variables that are set in oraenv.

Another question I have to ask – is the DB running?

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.


---------------------------------

From: joe bayer [mailto:joebayerii@yahoo.com]
Sent: Friday, March 23, 2007 4:25 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: RE: help with my perl script


Thanks for your prompt response.

I tried
$ENV{ORACLE_SID}=$ORACLE_SID or $ENV{ORACLE_SID}=”test”

It did not work.



"Reidy, Ron" wrote:
See below …




---------------------------------

From: joe bayer [mailto:joebayerii@yahoo.com]
Sent: Friday, March 23, 2007 3:33 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: help with my perl script




Dear group, I know it is not DBI related problem, but it is hard to find some one who knows perl, shell and Oracle.

I am trying to write a RMAN script,
======
#!/usr/bin/perl

my $ORACLE_HOME = "/opt/oracle/product_10g/test/10.2";
$ENV{ORACLE_HOME}=$ORACLE_HOME;
my $ORACLE_SID="test";
$ENV{ORACLE_SID}=test; # what is this? Shouldn’t this read $ENV{ORACLE_SID}=$ORACLE_SID or $ENV{ORACLE_SID}=”test”
my $backup_log = "/backup/backup_log.log";

open RMAN, "| /opt/oracle/product_10g/eratest/10.2/bin/rman target=sys/temp log=$backup_log" or die "Can't pipe to $!";
print RMAN "exit\n";
close RMAN;
======

It works in command line, but when I put it into crontab job, I always get
===================
connected to target database (not started)
RMAN>
===================
The script does not recognize the sid, what can I do to fix it?

Thanks very much for your help.




---------------------------------

No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.


---------------------------------
size=2 width="100%" align=center>
This electronic message transmission is a PRIVATE communication which contains information
which may be confidential or privileged. The information is intended to be for the use of the individual
or entity named above. If you are not the intended recipient, please be aware that any disclosure,
copying, distribution or use of the contents of this information is prohibited. Please notify the sender
of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0),
and then delete it from your system.



---------------------------------

No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.




---------------------------------
TV dinner still cooling?
Check out "Tonight's Picks" on Yahoo! TV.
--0-312298244-1174699665=:10696--

RE: help with my perl script

--0-1791777141-1174705963=:21794
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

I I just installed the ORACLE 10.2.0.3 to another home, and re-run the script, this time, even perl itself stopped running.
=======================
The script is like this:
#!/usr/bin/perl

my $ORACLE_HOME = "/opt/oracle/product_10g_2";
$ENV{ORACLE_HOME}=$ORACLE_HOME;
my $ORACLE_SID="test";
$ENV{ORACLE_SID}=$ORACLE_SID;
my $backup_log = "backup_log.log";

open RMAN, "| /opt/oracle/product_10g_2/bin/rman target=sys/temp" or die "Can't pipe to $!";
print RMAN "startup nomount\n";
print RMAN "exit\n";
close RMAN;
=====================

[ora92@eraapp4 dba]$ ps -eaf|grep pmon
ora92 8178 1 0 22:31 ? 00:00:00 ora_pmon_test
ora92 10212 1 0 23:04 ? 00:00:00 ora_pmon_test

The SID did passed, but somehow this "test" is different from that "test", how can that be possible?

Thanks for your help.


"Reidy, Ron" wrote: v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} st1\:*{behavior:url(#default#ieooui) } Then there is something wrong with your environment. Have you tried using oraenv to set you environment vs. setting the %ENV hash? In cron, it would look like this:

(export ORAENV_ASK=NO && export ORACLE_SID=test && . oraenv && /path/to/rman/script)

There are other environment variables that are set in oraenv.

Another question I have to ask – is the DB running?

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.


---------------------------------

From: joe bayer [mailto:joebayerii@yahoo.com]
Sent: Friday, March 23, 2007 4:25 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: RE: help with my perl script


Thanks for your prompt response.

I tried
$ENV{ORACLE_SID}=$ORACLE_SID or $ENV{ORACLE_SID}=”test”

It did not work.



"Reidy, Ron" wrote:
See below …




---------------------------------

From: joe bayer [mailto:joebayerii@yahoo.com]
Sent: Friday, March 23, 2007 3:33 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: help with my perl script




Dear group, I know it is not DBI related problem, but it is hard to find some one who knows perl, shell and Oracle.

I am trying to write a RMAN script,
======
#!/usr/bin/perl

my $ORACLE_HOME = "/opt/oracle/product_10g/test/10.2";
$ENV{ORACLE_HOME}=$ORACLE_HOME;
my $ORACLE_SID="test";
$ENV{ORACLE_SID}=test; # what is this? Shouldn’t this read $ENV{ORACLE_SID}=$ORACLE_SID or $ENV{ORACLE_SID}=”test”
my $backup_log = "/backup/backup_log.log";

open RMAN, "| /opt/oracle/product_10g/eratest/10.2/bin/rman target=sys/temp log=$backup_log" or die "Can't pipe to $!";
print RMAN "exit\n";
close RMAN;
======

It works in command line, but when I put it into crontab job, I always get
===================
connected to target database (not started)
RMAN>
===================
The script does not recognize the sid, what can I do to fix it?

Thanks very much for your help.




---------------------------------

No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.


---------------------------------
size=2 width="100%" align=center>
This electronic message transmission is a PRIVATE communication which contains information
which may be confidential or privileged. The information is intended to be for the use of the individual
or entity named above. If you are not the intended recipient, please be aware that any disclosure,
copying, distribution or use of the contents of this information is prohibited. Please notify the sender
of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0),
and then delete it from your system.



---------------------------------

No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.




---------------------------------
Be a PS3 game guru.
Get your game face on with the latest PS3 news and previews at Yahoo! Games.
--0-1791777141-1174705963=:21794--

RE: help with my perl script

------_=_NextPart_001_01C76ED1.BC327BC8
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

This tells me there is something not set in your environment. Have you
tried setting the environment like I specified?

=20

rr

=20

________________________________

From: joe bayer [mailto:joebayerii@yahoo.com]=20
Sent: Friday, March 23, 2007 7:28 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: RE: help with my perl script

=20

Yes, DB is running. If I run=20
../test.sh, there is no problem.

The problem comes only when I put it in cron.



"Reidy, Ron" wrote:

Then there is something wrong with your environment. Have you tried
using oraenv to set you environment vs. setting the %ENV hash? In cron,
it would look like this:

=20

(export ORAENV_ASK=3DNO && export ORACLE_SID=3Dtest && . oraenv &&
/path/to/rman/script)

=20

There are other environment variables that are set in oraenv.

=20

Another question I have to ask - is the DB running? =20

=20

--

Ron Reidy

Lead DBA

Array BioPharma, Inc.

=20

________________________________

From: joe bayer [mailto:joebayerii@yahoo.com]=20
Sent: Friday, March 23, 2007 4:25 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: RE: help with my perl script

=20

Thanks for your prompt response.

I tried=20
$ENV{ORACLE_SID}=3D$ORACLE_SID or $ENV{ORACLE_SID}=3D"test"

It did not work.



"Reidy, Ron" wrote:

See below ...

=20

________________________________

From: joe bayer [mailto:joebayerii@yahoo.com]=20
Sent: Friday, March 23, 2007 3:33 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: help with my perl script

=20

Dear group, I know it is not DBI related problem, but it is hard to
find some one who knows perl, shell and Oracle.

I am trying to write a RMAN script,=20
======
#!/usr/bin/perl

my $ORACLE_HOME =3D "/opt/oracle/product_10g/test/10.2";
$ENV{ORACLE_HOME}=3D$ORACLE_HOME;
my $ORACLE_SID=3D"test";
$ENV{ORACLE_SID}=3Dtest; # what is this? Shouldn't this read
$ENV{ORACLE_SID}=3D$ORACLE_SID or $ENV{ORACLE_SID}=3D"test"
my $backup_log =3D "/backup/backup_log.log";

open RMAN, "| /opt/oracle/product_10g/eratest/10.2/bin/rman
target=3Dsys/temp log=3D$backup_log" or die "Can't pipe to $!";
print RMAN "exit\n";
close RMAN;
======

It works in command line, but when I put it into crontab job, I always
get=20
===================3D
connected to target database (not started)
RMAN>=20
===================3D
The script does not recognize the sid, what can I do to fix it?

Thanks very much for your help.

=20

________________________________

No need to miss a message. Get email on-the-go
=20
with Yahoo! Mail for Mobile. Get started.
=20

________________________________

size=3D2 width=3D"100%" align=3Dcenter>=20

This electronic message transmission is a PRIVATE communication which
contains information=20
which may be confidential or privileged. The information is intended to
be for the use of the individual=20
or entity named above. If you are not the intended recipient, please be
aware that any disclosure,=20
copying, distribution or use of the contents of this information is
prohibited. Please notify the sender=20
of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0),=20
and then delete it from your system.

=20

=20

________________________________

No need to miss a message. Get email on-the-go
=20
with Yahoo! Mail for Mobile. Get started.
=20

=20

=20

________________________________

TV dinner still cooling?
Check out "Tonight's Picks"
on Yahoo! TV.


------_=_NextPart_001_01C76ED1.BC327BC8--

RE: help with my perl script

------_=_NextPart_001_01C76ED4.B139068A
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Because you pointed your ORACLE_HOME variable at this new install and
then issued "startup nomount" in your script, it just naturally follows
you would have a second instance up and running. So, obviously, perl is
working and so is your script.

=20

So, let's start over. You are trying to mimic an interactive session
with RMAN. I assume you are a DBA and you have read the Oracle backup
and recovery and RMAN documents. If you are not familiar with these,
you should read and understand them.

=20

Next, I suggest the following:

=20

1. Open a session on your server and Set your environment using
oraenv
2. Start RMAN like you would in your script.
3. Issue the commands you are trying to get your script to the RMAN
process you are running. Note the results.

=20

Do not set your environment using the %ENV hash - use oraenv. I cannot
stress this enough. I know one of the mantras of Perl is TMTOWTDI, but
this does not hold true for the use of oraenv. I have been a DBA for
almost 10 years and have been working with Perl since version 4 and this
is by far the easiest way to set up your environment and to keep things
running.

=20

Good luck.

=20

rr

=20

________________________________

From: joe bayer [mailto:joebayerii@yahoo.com]=20
Sent: Friday, March 23, 2007 9:13 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: RE: help with my perl script

=20

I I just installed the ORACLE 10.2.0.3 to another home, and re-run the
script, this time, even perl itself stopped running.
==================== ===3D
The script is like this:
#!/usr/bin/perl

my $ORACLE_HOME =3D "/opt/oracle/product_10g_2";
$ENV{ORACLE_HOME}=3D$ORACLE_HOME;
my $ORACLE_SID=3D"test";
$ENV{ORACLE_SID}=3D$ORACLE_SID;
my $backup_log =3D "backup_log.log";

open RMAN, "| /opt/oracle/product_10g_2/bin/rman target=3Dsys/temp" or =
die
"Can't pipe to $!";
print RMAN "startup nomount\n";
print RMAN "exit\n";
close RMAN;
==================== =3D

[ora92@eraapp4 dba]$ ps -eaf|grep pmon
ora92 8178 1 0 22:31 ? 00:00:00 ora_pmon_test
ora92 10212 1 0 23:04 ? 00:00:00 ora_pmon_test

The SID did passed, but somehow this "test" is different from that
"test", how can that be possible?

Thanks for your help.


"Reidy, Ron" wrote:

Then there is something wrong with your environment. Have you tried
using oraenv to set you environment vs. setting the %ENV hash? In cron,
it would look like this:

=20

(export ORAENV_ASK=3DNO && export ORACLE_SID=3Dtest && . oraenv &&
/path/to/rman/script)

=20

There are other environment variables that are set in oraenv.

=20

Another question I have to ask - is the DB running? =20

=20

--

Ron Reidy

Lead DBA

Array BioPharma, Inc.

=20

________________________________

From: joe bayer [mailto:joebayerii@yahoo.com]=20
Sent: Friday, March 23, 2007 4:25 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: RE: help with my perl script

=20

Thanks for your prompt response.

I tried=20
$ENV{ORACLE_SID}=3D$ORACLE_SID or $ENV{ORACLE_SID}=3D"test"

It did not work.



"Reidy, Ron" wrote:

See below ...

=20

________________________________

From: joe bayer [mailto:joebayerii@yahoo.com]=20
Sent: Friday, March 23, 2007 3:33 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: help with my perl script

=20

Dear group, I know it is not DBI related problem, but it is hard to
find some one who knows perl, shell and Oracle.

I am trying to write a RMAN script,=20
======
#!/usr/bin/perl

my $ORACLE_HOME =3D "/opt/oracle/product_10g/test/10.2";
$ENV{ORACLE_HOME}=3D$ORACLE_HOME;
my $ORACLE_SID=3D"test";
$ENV{ORACLE_SID}=3Dtest; # what is this? Shouldn't this read
$ENV{ORACLE_SID}=3D$ORACLE_SID or $ENV{ORACLE_SID}=3D"test"
my $backup_log =3D "/backup/backup_log.log";

open RMAN, "| /opt/oracle/product_10g/eratest/10.2/bin/rman
target=3Dsys/temp log=3D$backup_log" or die "Can't pipe to $!";
print RMAN "exit\n";
close RMAN;
======

It works in command line, but when I put it into crontab job, I always
get=20
===================3D
connected to target database (not started)
RMAN>=20
===================3D
The script does not recognize the sid, what can I do to fix it?

Thanks very much for your help.

=20

________________________________

No need to miss a message. Get email on-the-go
=20
with Yahoo! Mail for Mobile. Get started.
=20

________________________________

size=3D2 width=3D"100%" align=3Dcenter>=20

This electronic message transmission is a PRIVATE communication which
contains information=20
which may be confidential or privileged. The information is intended to
be for the use of the individual=20
or entity named above. If you are not the intended recipient, please be
aware that any disclosure,=20
copying, distribution or use of the contents of this information is
prohibited. Please notify the sender=20
of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0),=20
and then delete it from your system.

=20

=20

________________________________

No need to miss a message. Get email on-the-go
=20
with Yahoo! Mail for Mobile. Get started.
=20

=20

=20

________________________________

Be a PS3 game guru.
Get your game face on with the latest PS3 news and previews at Yahoo!
Games. =20


------_=_NextPart_001_01C76ED4.B139068A--

Re: help with my perl script

------=_Part_18345_27406385.1176308711498
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 3/25/07, Reidy, Ron wrote:
>
> This tells me there is something not set in your environment. Have you
> tried setting the environment like I specified?


Here's a handy method for getting the environment correct
in a script (DBI or otherwise) to run from cron when all
else seems to fail.

Most here probably know that cron does not setup the environment
when it runs a job. That is left up to you.

When a script is run withe 'at' utility however, entire environment is
dumped into a file to be used by 'at'.

Setup your job to run in the future with 'at', then you can use the
contents of the 'at' script to build a script for cron. I've used this
a couple times when scripts failed to run in cron, though I seemed
to have included every possible env variable.

example - run ls 1 hour from now:

9:12-jkstill-2 > at now + 1 hour
at> ls -l
at>
job 2 at 2007-04-11 10:13
[ /home/jkstill/tmp ]

9:13-jkstill-2 >

Now as root, navigate to the /var/spool/at directory.

[root /]# cd /var/spool/at
[root at]# ls -ltr
total 16
drwx------ 2 daemon daemon 4096 Dec 28 10:26 spool
-rwx------ 1 jkstill dba 3685 Apr 11 09:13 a00002012b26c9
[root at]#

The file a00002012b26c9 has all of my environment in it, followed by the
command to run.
There will be number of things that can obviously be removed from the file.

eg.

[root at]# cat a00002012b26c9
#!/bin/sh
# atrun uid=501 gid=300
# mail jkstill 0
umask 27
PATH=/home/jkstill/bin:/bin:/:/u01/app/perl/bin:/usr/bin:/us r/local/sbin:/usr/lib:/etc:/usr/local/bin:/home/jkstill/bin: /bin:/:/u01/app/perl/bin:/usr/bin:/usr/local/sbin:/usr/lib:/ etc:/usr/sbin:/home/jkstill/perl:/usr/X11R6/bin:/u01/app/ora cle/product/9.2.0/9ir2dev/bin;
export PATH
....
${SHELL:-/bin/sh} << `(dd if=/dev/urandom count=200 bs=1
2>/dev/null|LC_ALL=C tr -d -c '[:alnum:]')`

ls -l

HTH

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

------=_Part_18345_27406385.1176308711498--